Commit Transaction
AutomatR.MySQLDataBase.CommitTransaction
The "Commit Transaction" activity in AutomatR is part of the MySQL database activities package, facilitating the commitment of a transaction. This activity is essential for ensuring that changes made during the transaction are permanently saved to the database.
Properties
| Name | Description |
|---|---|
| Misc | |
| Display Name | Provides a customizable name for the activity displayed in the workflow. The display name enhances clarity and organization within the automation project. String variables containing the desired display name. |
| Optional | |
| Delay | Specifies the amount of time (in seconds) to wait before executing the "Commit Transaction" activity. This can be useful for handling synchronization issues. Integer variables containing the delay duration. Ex.: If the amount of time is 1000 milliseconds or 1 sec, i.e., 1. |
How to use:
- Drag and drop the "Commit Transaction" activity onto the workflow.
- Optionally, configure the delay for synchronization purposes.
- Ensure that the "Commit Transaction" activity is placed within a MySQL "Start Transaction" activity. This ensures that it is part of the transaction scope.
- Execute the workflow to commit the transaction.
Example: Consider an example where the "Commit Transaction" activity is used to commit changes made within a MySQL transaction:
Commit Transaction:
Delay: 0
In this example, the activity commits the changes made within the MySQL transaction. The delay is set to 0, indicating that there is no additional waiting time before committing the transaction.
Note: The "Commit Transaction" activity should always be used within the scope of a MySQL "Start Transaction" activity to ensure proper transaction handling.